Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

Excel user name

Get application user name or change it Originally from

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...